<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.Driver" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>修改</title>
</head>
<body>
<%@ include file="isLogin.jsp"%>


    <%
        request.setCharacterEncoding("utf8");

        String id = request.getParameter("id");
        String username = request.getParameter("username");
        String password = request.getParameter("password");

        Connection connection = null;
        Statement statement = null;

        String sql = "update t_users set username = '"+username+"'," +
                "password = '"+password+"' where id = " + id;

        Class.forName("com.mysql.jdbc.Driver");

        connection = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
                "root",
                "123456");
        statement = connection.createStatement();

        statement.execute(sql);

        statement.close();
        connection.close();

    %>

更新成功！！！
    <%--<%@ include file="footer.jsp" %>--%>
<jsp:include page="footer.jsp">
    <jsp:param name="year" value="2016" />
</jsp:include>

</body>
</html>
